'Inventory.sam.sht
'AmiSoft!
@TODAY
'Inventory Control Sheet
@TODAY
'Inventory
'Item
'Unit 
'Beginning Inventory
'          Purchases
'  Purchases
'Item
'Total Available
'Available
' Unit
'Ending Inventory
'Total Consumed
'disc.
'count
'Units
'     $
'Units
'/    $
'Units
'/   $
'disc.
'Units
'    $
' Price
'Units
'   $
'Unit
'apples
'apples
+C7+E7+G7
+D7+F7+H7
+K7/J7
+M7*L7
+J7-M7
+K7-N7
'books
'books
+C8+E8+G8
+D8+F8+H8
+K8/J8
+M8*L8
+J8-M8
+K8-N8
'computers
'computers
+C9+E9+G9
+D9+F9+H9
+K9/J9
+M9*L9
+J9-M9
+K9-N9
'disks
'disks
+C10+E10+G10
+D10+F10+H10
F+K10/J10
u+M10*L10
+J10-M10
+K10-N10
'eggs
'eggs
+C11+E11+G11
+D11+F11+H11
UUUUUU+K11/J11
+M11*L11
+J11-M11
+K11-N11
'forms
'forms
+C12+E12+G12
+K12/J12
+M12*L12
+J12-M12
+K12-N12
'game
'game
+C13+E13+G13
+D13+F13+H13
+K13/J13
+M13*L13
+J13-M13
+K13-N13
'hats
'hats
+C14+E14+G14
ffffg+D14+F14+H14
'+K14/J14
+M14*L14
+J14-M14
+K14-N14
'ink pens
'ink pens
+C15+E15+G15
+D15+F15+H15
+K15/J15
+M15*L15
+J15-M15
+K15-N15
'juice
'juice
+C16+E16+G16
+D16+F16+H16
+K16/J16
+M16*L16
+J16-M16
+K16-N16
'keys
'keys
+C17+E17+G17
+D17+F17+H17
+K17/J17
+M17*L17
+J17-M17
+K17-N17
'locks
'locks
+C18+E18+G18
+D18+F18+H18
+K18/J18
+M18*L18
+J18-M18
+K18-N18
'mats
'mats
+C19+E19+G19
>+D19+F19+H19
+K19/J19
+M19*L19
+J19-M19
+K19-N19
'nuts
'nuts
+C20+E20+G20
+D20+F20+H20
n+K20/J20
n+M20*L20
+J20-M20
p+K20-N20
	'oranges
333333
	'oranges
+C21+E21+G21
H+D21+F21+H21
+K21/J21
+M21*L21
+J21-M21
+K21-N21
	'pickles
	'pickles
+C22+E22+G22
+D22+F22+H22
+K22/J22
33334+M22*L22
+J22-M22
+K22-N22
'quilts
'quilts
+C23+E23+G23
+D23+F23+H23
@4ffffff+K23/J23
@4ffffff+M23*L23
+J23-M23
@Tfffffg+K23-N23
'radios
'radios
+C24+E24+G24
+D24+F24+H24
+K24/J24
+M24*L24
+J24-M24
+K24-N24
'stamps
'stamps
+C25+E25+G25
+D25+F25+H25
\)+K25/J25
+M25*L25
+J25-M25
\+K25-N25
'tacos
'tacos
+C26+E26+G26
+D26+F26+H26
+K26/J26
+M26*L26
+J26-M26
+K26-N26
'unicorns
fffff
'unicorns
+C27+E27+G27
33333+D27+F27+H27
+K27/J27
+M27*L27
+J27-M27
33333+K27-N27
'valves
'valves
+C28+E28+G28
+D28+F28+H28
+K28/J28
+M28*L28
+J28-M28
+K28-N28
'worms
'worms
+C29+E29+G29
+D29+F29+H29
+K29/J29
+M29*L29
+J29-M29
i+K29-N29
'yoyos
'yoyos
+C30+E30+G30
R+D30+F30+H30
+K30/J30
R+M30*L30
+J30-M30
{+K30-N30
	'zippers
	'zippers
+D31+F31+H31
+K31/J31
+M31*L31
+J31-M31
+K31-N31
'TOTALS
\)@SUM(D7..D31)
@SUM(F7..F31)
@SUM(H7..H31)
I@SUM(K7..K31)
@SUM(N7..N31)
@SUM(P7..P31)
'Inventory
'Analysis
'Sales
'Percent of Sales
'Beginning 
'Inventory
+D37/D36
'Plus Purchases
fffff+F33+H33
+D38/D36
'= Total Available
H+D37+D38
Q+D39/D36
'- Ending Inventory
8uv+D40/D36
'= Amount Consumed
+D39-D40
+D41/D36